<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>学生信息删除</title>
</head>
<body bgcolor="d2e9ff">
    <jsp:useBean id="dbconn" class="bean.DBConnectionManager"></jsp:useBean>
   <%
    //DBConnectionManager dbconn=new DBConnectionManager();
    Connection con=dbconn.getConnection();
 Statement stmt=con.createStatement(); 
 %>
<center>
  <br><br><br>
  <br><br><br>
  <h2>删除学生信息</h2><br>
  <form action="deleteStudentCheck.jsp" method="post">
    <p>请选择要删除学生的学号：
      <select name="id">
        <%
          String sql="select * from t_student";
          ResultSet rs=stmt.executeQuery(sql);
          while(rs.next()){
        	  String SNo=rs.getString("stuno");
        %>
        <option value="<%=SNo%>"><%=SNo %></option>
        <%
          }
        %> 
      </select>
    </p>
    <p>
    <input type="submit" value="确定">&nbsp;
    <input type="button" value="返回" onclick="javascript:history.go(-1)">    
    </p>
  </form>
</center>
</body>
</html>